pgwui_sql
2 years agoAdjust javascript to account for using static paths instead of urls
Karl O. Pinc [Sat, 5 Oct 2024 00:20:27 +0000 (19:20 -0500)]
Adjust javascript to account for using static paths instead of urls

2 years agoUse static paths instead of static URLs to ease reverse-proxying
Karl O. Pinc [Fri, 4 Oct 2024 22:20:57 +0000 (17:20 -0500)]
Use static paths instead of static URLs to ease reverse-proxying

2 years agoBump version number to 0.21.0
Karl O. Pinc [Fri, 4 Oct 2024 20:55:24 +0000 (15:55 -0500)]
Bump version number to 0.21.0

2 years agoBump version number to 0.20.0
Karl O. Pinc [Fri, 4 Oct 2024 20:50:27 +0000 (15:50 -0500)]
Bump version number to 0.20.0

2 years agoInstall the extra testing dependencies when testing
Karl O. Pinc [Fri, 4 Oct 2024 20:44:14 +0000 (15:44 -0500)]
Install the extra testing dependencies when testing

2 years agoSupport downloading one file per result set as separate files of a zip file
Karl O. Pinc [Wed, 2 Oct 2024 19:45:19 +0000 (14:45 -0500)]
Support downloading one file per result set as separate files of a zip file

2 years agoFix so csv downloads work
Karl O. Pinc [Wed, 2 Oct 2024 19:42:59 +0000 (14:42 -0500)]
Fix so csv downloads work

2 years agoFix so colons (:) do not appear in the downloaded filename
Karl O. Pinc [Wed, 2 Oct 2024 19:40:17 +0000 (14:40 -0500)]
Fix so colons (:) do not appear in the downloaded filename

2 years agoLog whether download happened
Karl O. Pinc [Wed, 2 Oct 2024 19:20:12 +0000 (14:20 -0500)]
Log whether download happened

2 years agoTrap out of disk errors
Karl O. Pinc [Wed, 2 Oct 2024 17:19:50 +0000 (12:19 -0500)]
Trap out of disk errors

2 years agoMay as well trap out-of-memory all the time
Karl O. Pinc [Wed, 2 Oct 2024 16:57:00 +0000 (11:57 -0500)]
May as well trap out-of-memory all the time

2 years agoImprove phrasing
Karl O. Pinc [Tue, 1 Oct 2024 12:36:19 +0000 (07:36 -0500)]
Improve phrasing

2 years agoVisually show that zip file downloads always include the executed SQL
Karl O. Pinc [Mon, 30 Sep 2024 16:51:06 +0000 (11:51 -0500)]
Visually show that zip file downloads always include the executed SQL

Check, disable, and grey-out the Include SQL checkbox when downloading
a zip file.

2 years agoProperly attach the zip file download text to the radio button
Karl O. Pinc [Mon, 30 Sep 2024 16:48:36 +0000 (11:48 -0500)]
Properly attach the zip file download text to the radio button

2 years agoFix reset search_path button
Karl O. Pinc [Mon, 30 Sep 2024 14:29:46 +0000 (09:29 -0500)]
Fix reset search_path button

2 years agoAttach onchange event of upload SQL checkbox with javascript instead of HTML
Karl O. Pinc [Mon, 30 Sep 2024 14:16:18 +0000 (09:16 -0500)]
Attach onchange event of upload SQL checkbox with javascript instead of HTML

2 years agoChange function name to conform to javascript conventions
Karl O. Pinc [Mon, 30 Sep 2024 14:06:13 +0000 (09:06 -0500)]
Change function name to conform to javascript conventions

2 years agoAdd comments
Karl O. Pinc [Mon, 30 Sep 2024 14:03:20 +0000 (09:03 -0500)]
Add comments

2 years agoUse a more descriptive id
Karl O. Pinc [Mon, 30 Sep 2024 14:02:47 +0000 (09:02 -0500)]
Use a more descriptive id

2 years agoThe same class is used for both input and output of SQL
Karl O. Pinc [Mon, 30 Sep 2024 13:54:29 +0000 (08:54 -0500)]
The same class is used for both input and output of SQL

2 years agoGarbage collect when out of memory
Karl O. Pinc [Mon, 30 Sep 2024 13:49:48 +0000 (08:49 -0500)]
Garbage collect when out of memory

2 years agoRefactor and download with ".zip" suffix when downloading multiple files
Karl O. Pinc [Mon, 30 Sep 2024 03:35:31 +0000 (22:35 -0500)]
Refactor and download with ".zip" suffix when downloading multiple files

2 years agoPrevent a click on the download help from toggling the downlaod checkbox
Karl O. Pinc [Mon, 30 Sep 2024 03:19:13 +0000 (22:19 -0500)]
Prevent a click on the download help from toggling the downlaod checkbox

A <label with for=> is simulated in javascript.  This is less than
ideal for accessability.

2 years agoSupport tab-delimited download format
Karl O. Pinc [Mon, 30 Sep 2024 01:08:42 +0000 (20:08 -0500)]
Support tab-delimited download format

2 years agoSuggest downloading when server is out of ram
Karl O. Pinc [Mon, 30 Sep 2024 00:39:08 +0000 (19:39 -0500)]
Suggest downloading when server is out of ram

2 years agoAdd help text to say downloads do not use server RAM
Karl O. Pinc [Mon, 30 Sep 2024 00:24:47 +0000 (19:24 -0500)]
Add help text to say downloads do not use server RAM

2 years agoAttach events to HTML elements with javascript
Karl O. Pinc [Mon, 30 Sep 2024 00:16:33 +0000 (19:16 -0500)]
Attach events to HTML elements with javascript

2 years agoRewrite so downloads do not put sql results in RAM
Karl O. Pinc [Sun, 29 Sep 2024 22:55:42 +0000 (17:55 -0500)]
Rewrite so downloads do not put sql results in RAM

2 years agoTrap and report errors from the csv module
Karl O. Pinc [Sun, 29 Sep 2024 22:14:09 +0000 (17:14 -0500)]
Trap and report errors from the csv module

2 years agoMake the Include SQL (in the download) checkbox work
Karl O. Pinc [Sun, 29 Sep 2024 22:03:04 +0000 (17:03 -0500)]
Make the Include SQL (in the download) checkbox work

2 years agoFix so text columns containing numbers are downloaded as text
Karl O. Pinc [Sun, 29 Sep 2024 21:43:35 +0000 (16:43 -0500)]
Fix so text columns containing numbers are downloaded as text

2 years agoFix affected rows row in downloads
Karl O. Pinc [Sun, 29 Sep 2024 21:24:06 +0000 (16:24 -0500)]
Fix affected rows row in downloads

2 years agoFix so status rows are not one-character per column
Karl O. Pinc [Sun, 29 Sep 2024 21:23:17 +0000 (16:23 -0500)]
Fix so status rows are not one-character per column

2 years agoMake initial sql_edit window a little taller
Karl O. Pinc [Sun, 29 Sep 2024 20:39:29 +0000 (15:39 -0500)]
Make initial sql_edit window a little taller

2 years agoApply the sqltext class to <li> elements to display whitespace in sql
Karl O. Pinc [Sun, 29 Sep 2024 20:16:45 +0000 (15:16 -0500)]
Apply the sqltext class to <li> elements to display whitespace in sql

2 years agoTest additional parts of the sql.mak template
Karl O. Pinc [Sun, 29 Sep 2024 19:34:48 +0000 (14:34 -0500)]
Test additional parts of the sql.mak template

2 years agoPass template a "locals" dict so it can modify variables
Karl O. Pinc [Sun, 29 Sep 2024 19:33:41 +0000 (14:33 -0500)]
Pass template a "locals" dict so it can modify variables

2 years agoNormalize newlines of sql from textarea and for sql output
Karl O. Pinc [Sun, 29 Sep 2024 17:09:31 +0000 (12:09 -0500)]
Normalize newlines of sql from textarea and for sql output

2 years agoImprove heading of eol concern text
Karl O. Pinc [Fri, 27 Sep 2024 00:28:44 +0000 (19:28 -0500)]
Improve heading of eol concern text

2 years agoPresent user with information about EOL normalization
Karl O. Pinc [Thu, 26 Sep 2024 20:35:01 +0000 (15:35 -0500)]
Present user with information about EOL normalization

2 years agoMove sql_edit javascript into its own file
Karl O. Pinc [Thu, 26 Sep 2024 20:14:34 +0000 (15:14 -0500)]
Move sql_edit javascript into its own file

2 years agoAdd a help caution regarding tab-delimited downloads
Karl O. Pinc [Thu, 26 Sep 2024 16:23:34 +0000 (11:23 -0500)]
Add a help caution regarding tab-delimited downloads

2 years agoUse proper mako markup when invoking self.lib
Karl O. Pinc [Thu, 26 Sep 2024 15:17:00 +0000 (10:17 -0500)]
Use proper mako markup when invoking self.lib

2 years agoAdjust heading based on logged-in status
Karl O. Pinc [Thu, 26 Sep 2024 15:10:56 +0000 (10:10 -0500)]
Adjust heading based on logged-in status

2 years agoTweak css to align rule background vertically
Karl O. Pinc [Thu, 26 Sep 2024 15:04:18 +0000 (10:04 -0500)]
Tweak css to align rule background vertically

2 years agoAdd "Show rules" checkbox and attendent css and js
Karl O. Pinc [Wed, 25 Sep 2024 20:09:00 +0000 (15:09 -0500)]
Add "Show rules" checkbox and attendent css and js

The only problem here is that as the column headings stick to the
page their background covers only the columns, not the entire
width of the screen/enclosing div.  Which means that when background
rules are displayed they are uncovered in the horizontal area
where the table headings appear.  The backround_rules.css
_could_ apply the rules to the table instead of the div, but then
the rules don't go all the way across the page.

There is surely a way to fiddle with this but it's not worth bothering
with now.

2 years agoAbstract getting a sheet with an url
Karl O. Pinc [Wed, 25 Sep 2024 19:07:27 +0000 (14:07 -0500)]
Abstract getting a sheet with an url

2 years agoAbstract control over checkboxs that disable stylesheet elements
Karl O. Pinc [Wed, 25 Sep 2024 18:28:47 +0000 (13:28 -0500)]
Abstract control over checkboxs that disable stylesheet elements

2 years agoImprove commenting and formatting
Karl O. Pinc [Wed, 25 Sep 2024 18:22:11 +0000 (13:22 -0500)]
Improve commenting and formatting

2 years agoUse child CSS selectors so we only have to attach class to the table body
Karl O. Pinc [Wed, 25 Sep 2024 16:40:58 +0000 (11:40 -0500)]
Use child CSS selectors so we only have to attach class to the table body

2 years agoRemove unused mako "result_form" def
Karl O. Pinc [Wed, 25 Sep 2024 04:02:25 +0000 (23:02 -0500)]
Remove unused mako "result_form" def

2 years agoMake the show spaces function of the sql results page work
Karl O. Pinc [Wed, 25 Sep 2024 03:56:44 +0000 (22:56 -0500)]
Make the show spaces function of the sql results page work

2 years agoInitial attempt at showing whitespace in SQL results
Karl O. Pinc [Tue, 24 Sep 2024 22:13:08 +0000 (17:13 -0500)]
Initial attempt at showing whitespace in SQL results

2 years agoPreserve spacig and line-breaks in sql result output
Karl O. Pinc [Tue, 24 Sep 2024 18:48:10 +0000 (13:48 -0500)]
Preserve spacig and line-breaks in sql result output

2 years agoPreserve spaces and line-breaks when displaying the SQL entered
Karl O. Pinc [Tue, 24 Sep 2024 18:47:18 +0000 (13:47 -0500)]
Preserve spaces and line-breaks when displaying the SQL entered

2 years agoRename the base SQL form classes to reflect their "base" character
Karl O. Pinc [Tue, 24 Sep 2024 17:51:25 +0000 (12:51 -0500)]
Rename the base SQL form classes to reflect their "base" character

2 years agoRemove extra line between error message(s) and sql statements
Karl O. Pinc [Sat, 21 Sep 2024 19:31:07 +0000 (14:31 -0500)]
Remove extra line between error message(s) and sql statements

2 years agoFix crash when sql execution error has no line number
Karl O. Pinc [Sat, 21 Sep 2024 18:54:47 +0000 (13:54 -0500)]
Fix crash when sql execution error has no line number

2 years agoMake downloading CSV work
Karl O. Pinc [Sat, 21 Sep 2024 03:27:12 +0000 (22:27 -0500)]
Make downloading CSV work

2 years agoAlign column headings left, just like column data
Karl O. Pinc [Sat, 21 Sep 2024 03:27:05 +0000 (22:27 -0500)]
Align column headings left, just like column data

2 years agoUse ? instead of * for help links
Karl O. Pinc [Fri, 20 Sep 2024 20:18:45 +0000 (15:18 -0500)]
Use ? instead of * for help links

2 years agoAdd field for null representation output
Karl O. Pinc [Fri, 20 Sep 2024 18:03:04 +0000 (13:03 -0500)]
Add field for null representation output

2 years agoSimplify template rendering
Karl O. Pinc [Thu, 19 Sep 2024 18:30:58 +0000 (13:30 -0500)]
Simplify template rendering

2 years agoMove logging into a function
Karl O. Pinc [Thu, 19 Sep 2024 18:28:12 +0000 (13:28 -0500)]
Move logging into a function

2 years agoMove "include sql" into the "grid of controls"
Karl O. Pinc [Wed, 18 Sep 2024 19:09:39 +0000 (14:09 -0500)]
Move "include sql" into the "grid of controls"

2 years agoUse a lighter than lightgrey to grey out the sql text when unused
Karl O. Pinc [Wed, 18 Sep 2024 18:56:04 +0000 (13:56 -0500)]
Use a lighter than lightgrey to grey out the sql text when unused

2 years agoAdd user interface elements supporting download
Karl O. Pinc [Wed, 18 Sep 2024 18:22:44 +0000 (13:22 -0500)]
Add user interface elements supporting download

2 years agoHave column headings in SQL results "stick" on the page
Karl O. Pinc [Tue, 17 Sep 2024 22:58:26 +0000 (17:58 -0500)]
Have column headings in SQL results "stick" on the page

2 years agoAdd alert when javascript is turned off
Karl O. Pinc [Tue, 17 Sep 2024 17:06:26 +0000 (12:06 -0500)]
Add alert when javascript is turned off

2 years agoStyle horizontal rules between sql results to be very light
Karl O. Pinc [Mon, 16 Sep 2024 22:26:30 +0000 (17:26 -0500)]
Style horizontal rules between sql results to be very light

2 years agoAdd ability to supply sql via a file
Karl O. Pinc [Mon, 16 Sep 2024 04:17:55 +0000 (23:17 -0500)]
Add ability to supply sql via a file

2 years agoGet rid of example settings error
Karl O. Pinc [Mon, 16 Sep 2024 02:44:46 +0000 (21:44 -0500)]
Get rid of example settings error

2 years agoMove the search_path Reset button closer to the input element
Karl O. Pinc [Mon, 16 Sep 2024 00:43:13 +0000 (19:43 -0500)]
Move the search_path Reset button closer to the input element

2 years agoAdd "Reset" button to reset back to default search_path
Karl O. Pinc [Sun, 15 Sep 2024 23:04:27 +0000 (18:04 -0500)]
Add "Reset" button to reset back to default search_path

2 years agoMove away from XML formatting
Karl O. Pinc [Sun, 15 Sep 2024 22:32:25 +0000 (17:32 -0500)]
Move away from XML formatting

2 years agoProvide a help link for search_path
Karl O. Pinc [Sun, 15 Sep 2024 20:50:48 +0000 (15:50 -0500)]
Provide a help link for search_path

2 years agoPrevent crash of sql editing page when user is not logged in
Karl O. Pinc [Sun, 15 Sep 2024 19:56:57 +0000 (14:56 -0500)]
Prevent crash of sql editing page when user is not logged in

2 years agoApply the requested search_path before executing the supplied SQL
Karl O. Pinc [Sun, 15 Sep 2024 19:42:37 +0000 (14:42 -0500)]
Apply the requested search_path before executing the supplied SQL

2 years agoGive the requested search_path to the html template
Karl O. Pinc [Sun, 15 Sep 2024 18:55:51 +0000 (13:55 -0500)]
Give the requested search_path to the html template

2 years agoRefactor to put search_path code it a separate module
Karl O. Pinc [Sun, 15 Sep 2024 18:34:06 +0000 (13:34 -0500)]
Refactor to put search_path code it a separate module

2 years agoShow search_path in SQL entry window
Karl O. Pinc [Sat, 14 Sep 2024 23:05:47 +0000 (18:05 -0500)]
Show search_path in SQL entry window

2 years agopgwui_server is required for tox testing of template rendering
Karl O. Pinc [Fri, 13 Sep 2024 19:04:49 +0000 (14:04 -0500)]
pgwui_server is required for tox testing of template rendering

2 years agoExplain why we can safely use the SQLHander to process the SQL edit form
Karl O. Pinc [Fri, 13 Sep 2024 18:54:36 +0000 (13:54 -0500)]
Explain why we can safely use the SQLHander to process the SQL edit form

2 years agoRemove blank line
Karl O. Pinc [Fri, 13 Sep 2024 18:52:47 +0000 (13:52 -0500)]
Remove blank line

2 years agoDon't try to automatically open a SQL edit window
Karl O. Pinc [Fri, 13 Sep 2024 18:40:48 +0000 (13:40 -0500)]
Don't try to automatically open a SQL edit window

The problem is that the current sql is not passed to the sql edit
window.  So the new window always opens with no sql.  Changing this
is more bother than it's worth.  At least right now.

2 years agoRequire logging in before use of the sql edit popup
Karl O. Pinc [Fri, 13 Sep 2024 18:24:08 +0000 (13:24 -0500)]
Require logging in before use of the sql edit popup

2 years agoLabel button to match sql edit window title
Karl O. Pinc [Fri, 13 Sep 2024 18:06:20 +0000 (13:06 -0500)]
Label button to match sql edit window title

2 years agoPosition and size, more or less correctly, sql edit window
Karl O. Pinc [Fri, 13 Sep 2024 18:05:47 +0000 (13:05 -0500)]
Position and size, more or less correctly, sql edit window

2 years agoChange window title when showing sql results
Karl O. Pinc [Fri, 13 Sep 2024 17:38:27 +0000 (12:38 -0500)]
Change window title when showing sql results

2 years agoRemove navigation menu from popup sql edit window
Karl O. Pinc [Fri, 13 Sep 2024 16:22:06 +0000 (11:22 -0500)]
Remove navigation menu from popup sql edit window

2 years agoA working control flow from login to sql edit window opening
Karl O. Pinc [Fri, 13 Sep 2024 15:48:48 +0000 (10:48 -0500)]
A working control flow from login to sql edit window opening

2 years agoAdd "login" user interface when not logged in
Karl O. Pinc [Wed, 11 Sep 2024 23:00:02 +0000 (18:00 -0500)]
Add "login" user interface when not logged in

2 years agoTest that templates render, at least somewhat
Karl O. Pinc [Wed, 11 Sep 2024 00:17:51 +0000 (19:17 -0500)]
Test that templates render, at least somewhat

2 years agoBeginnings of a SQL edit window
Karl O. Pinc [Tue, 3 Sep 2024 19:17:53 +0000 (14:17 -0500)]
Beginnings of a SQL edit window

2 years agoImprove code formatting
Karl O. Pinc [Tue, 3 Sep 2024 19:16:33 +0000 (14:16 -0500)]
Improve code formatting

2 years agoBetter menu label
Karl O. Pinc [Tue, 20 Aug 2024 20:25:40 +0000 (15:25 -0500)]
Better menu label

2 years agoBump version number to 0.19.0
Karl O. Pinc [Tue, 20 Aug 2024 19:55:40 +0000 (14:55 -0500)]
Bump version number to 0.19.0

2 years agoStyle SQL text in a monospace font
Karl O. Pinc [Tue, 20 Aug 2024 01:06:07 +0000 (20:06 -0500)]
Style SQL text in a monospace font

2 years agoStyle the PGResult status message
Karl O. Pinc [Tue, 20 Aug 2024 00:56:45 +0000 (19:56 -0500)]
Style the PGResult status message

2 years agoGive the component it's own CSS file
Karl O. Pinc [Tue, 20 Aug 2024 00:56:09 +0000 (19:56 -0500)]
Give the component it's own CSS file